﻿CREATE TABLE [dbo].[ClaimTypeGroup] (
    [ClaimGroupId]    INT          IDENTITY (1, 1) NOT NULL,
    [ApplicationId]   INT          CONSTRAINT [DF_ClaimTypeGroup_EnterpriseId] DEFAULT ((1)) NOT NULL,
    [Name]            VARCHAR (50) NOT NULL,
    [adt_DateCreated] DATETIME     CONSTRAINT [DF_ClaimTypeGroup_adt_DateCreated] DEFAULT (getdate()) NOT NULL,
    [adt_CreatedBy]   VARCHAR (50) NULL,
    CONSTRAINT [PK_ClaimTypeGroup] PRIMARY KEY CLUSTERED ([ClaimGroupId] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_ClaimTypeGroup]
    ON [dbo].[ClaimTypeGroup]([Name] ASC);

